create  table jms_dm.dm_send_no_arrival_detail_dt
(
date_time date COMMENT 'date_time' ,
id  varchar(100) COMMENT '问题件表id' ,
waybill_no varchar(100) COMMENT '问题件表运单号' ,
create_time datetime COMMENT '问题件登记时间' ,
registration_network_name   varchar(100) COMMENT '登记网点' ,
registration_network_code varchar(100) COMMENT '登记网点code' ,
is_error  bigint COMMENT '是否异常，1是，0否' ,
is_error_type bigint COMMENT '异常，判断类型'
 )
ENGINE=OLAP
DUPLICATE KEY(date_time,id)
comment '有发未到问题件'
PARTITION BY RANGE (date_time) ( 
   START ("2022-08-14") END ("2022-11-13") EVERY (INTERVAL 1 day))DISTRIBUTED BY HASH(date_time,id) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);